from google.appengine.ext import db 

class OrderData(db.Model):
    
    order_number            = db.StringProperty()
    
    order_author            = db.UserProperty()
    order_dept              = db.StringProperty()
    order_author_title      = db.StringProperty()
    order_date              = db.DateTimeProperty()
    
    estimate_contact_author         = db.StringProperty()
    estimate_contact_dept           = db.StringProperty()
    estimate_contact_author_title   = db.StringProperty()
    estimate_contact_date           = db.DateTimeProperty()
    
    operation_author         = db.StringProperty()
    operation_dept           = db.StringProperty()
    operation_author_title   = db.StringProperty()
    operation_date           = db.DateTimeProperty()
    
    confirm_author         = db.StringProperty()
    confirm_dept           = db.StringProperty()
    confirm_author_title   = db.StringProperty()
    confirm_date           = db.DateTimeProperty()

    complete_contact_author         = db.StringProperty()
    complete_contact_dept           = db.StringProperty()
    complete_contact_author_title   = db.StringProperty()
    complete_contact_date           = db.DateTimeProperty()
    
    confirm_status          = db.StringProperty()
    confirm_message         = db.StringProperty()
    
    company_code            = db.StringProperty()
    company_name            = db.StringProperty()
    company_type            = db.StringProperty()
    company_service         = db.StringProperty()
    
    order_type              = db.StringProperty()
    order_content           = db.StringProperty(multiline=True)
    order_effect            = db.StringProperty(multiline=True)
    
    demand_release_date     = db.DateProperty()
    demand_service_date     = db.DateProperty()
    
    estimate_author         = db.StringProperty()
    estimate_develop        = db.BooleanProperty()
    estimate_cost           = db.StringProperty(multiline=True)
    estimate_release        = db.DateProperty()
    estimate_message        = db.StringProperty()
    
    complete_frontse        = db.StringProperty()
    complete_se             = db.StringProperty()
    complete_pg             = db.StringProperty()
    complete_status         = db.StringProperty()
    
    complete_service_date   = db.StringProperty()
    complete_message        = db.StringProperty()
    
    business_conditions     = db.StringListProperty()
#    categories              = db.StringListProperty()
    stocktaking_methods     = db.StringListProperty()
    classification          = db.StringProperty()
    need_program            = db.StringProperty()
    
    content                 = db.TextProperty()
    effective               = db.TextProperty()
    
#    attached_files          = db.StringListProperty()
    attched_file_name       = db.StringProperty()
    attched_file            = db.BlobProperty()
    filenameKey1            = db.StringProperty()
    tempfile_key            = db.StringListProperty()
    tempfile_name           = db.StringListProperty()
    last_modify_time        = db.DateTimeProperty(auto_now_add=True)
    